<?php
############## DIT STUK CODE ZORGT ERVOOR DAT JE ALS ADMIN INGELOGD MOET ZIJN OM DE PAGINA TE KUNNEN ZIEN ##############
    //Start de sessie
    session_start();

    //Load de benodigde bestanden
    require_once("includes/auth.php");
########################################################################################################################
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <title>Pagina bewerken</title>
 <meta http-equiv="content-type" content="text/html; charset=utf-8" />
  <link type="text/css" href="../css/pagination.css" rel="stylesheet" />
  <link rel="stylesheet" href="../css/reset.css" type="text/css" />
  <link rel="stylesheet" href="../css/960.css" type="text/css" />
  <link rel="stylesheet" href="../css/text.css" type="text/css" />
  <link type="text/css" href="../css/tablesorter.css" rel="stylesheet" />
  <link type="text/css" href="../css/sunny/jquery-ui-1.8.custom.css" rel="stylesheet" />
  <link type="text/css" href="../css/jquery.autocomplete.css" rel="stylesheet" />
  <link type="text/css" href="../css/style.css" rel="stylesheet" />
  <link type="text/css" href="../css/accmenu.css" rel="stylesheet" />
<script type="text/javascript" src="../js/jquery-1.4.2.min.js">
</script>
<script type="text/javascript" src="../js/jquery-ui-1.8.custom.min.js">
</script>
<script type="text/javascript" src="../js/jquery.tablesorter.js">
</script>
<script type="text/javascript" src="../js/jquery.autocomplete.min.js">
</script>
<script type="text/javascript" src="../js/menu.js">
</script>

</head>

<body>
  <div class="container_12">
    <div id="header" class="grid_12">

    </div>

    <div class="clear"></div>

    <div class="grid_12 spacer"></div>

    <div class="clear"></div>

    <div id="menu" class="grid_2">

        <?php
        include_once 'temp/menu_filler.php';
        ?>


    </div>

    <div id="adminarea" class="grid_10">
        <div id="tableholder">

                <?php

                // Connects to your Database
                include 'includes/connect.php';

                // TinyMCE grafische editor laden
                include 'includes/loadtinymce.php';

                if (!isset($_POST['submit'])) // if page is not submitted to itself echo the form
                {
                  // Retrieve all the data from the table
                  $result = mysql_query("SELECT * FROM page WHERE pagename='". $_GET['p'] ."'")
                  or die(mysql_error());

                  // store the record of the table into $row
                  $row = mysql_fetch_array($result);

                  // Print out the contents of the entry
                  $page=$_GET['p'];

                  $pid = $row['pageid'];
                  $pn = $row['pagename'];
                  $pt = $row['pagetitle'];
                  $pc = $row['pagecontent'];
                ?>
                    <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
                    <input type= "hidden" name= "pageid" value="<?php echo $pid ?>" />
                    Paginanaam (back-end): <input type="text" name="pagename" value="<?php echo $pn ?>" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Paginatitel (zichtbaar): <input type="text" name="pagetitle" value="<?php echo $pt ?>" /><br /><br />
                    Inhoud: <textarea name="pagecontent" class="tinymce" cols=10 rows=5> <?php echo $pc ?> </textarea><br /><br />
                    <input type="submit" name="submit" value="opslaan">
                    </form>
                    <?php
                }
                else
                {
                    $sql="UPDATE page SET pagename='$_POST[pagename]',pagetitle='$_POST[pagetitle]',pagecontent='$_POST[pagecontent]' WHERE pageid='". $_POST['pageid'] ."' ";

                    if (!mysql_query($sql))
                      {
                      die('Error: ' . mysql_error());
                      }
                    echo "Product gewijzigd!";
                    echo "<br />";
                    echo "<a href=\" manage_page.php \"> Terug naar Paginabeheer";



                }

                ?>

        </div>
    </div>

    <div class="clear"></div>

    <div class="grid_12 spacer"></div>

    <div class="clear"></div>
</div>
</body>
</html>